﻿Create database WooCooTest on primary (name='WooCooTest',filename = 'C:\Users\清山\Documents\Code\WooCoo\DataBase\WooCooTest.mdf');

CREATE TABLE [dbo].[OrgInfo]
(
	[KeyID] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY, 
    [OrgID] INT NULL, 
    [OrgName] NVARCHAR(50) NULL
);

CREATE TABLE [dbo].[UserInfo]
(
	[KeyID] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY, 
    [UserID] INT NULL, 
    [UserName] NVARCHAR(50) NULL, 
    [FirstName] NVARCHAR(50) NULL, 
    [OrgKeyID] UNIQUEIDENTIFIER NULL
)


